UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8tu1GoV0HzOa87K+eyhdCbrIq/Ha4iaVYYaXpD2o8eU='
WHERE
key_id = 'c0c41c4880ae96f37488fa86b5e7300605dbc7d92d29aef0e7482033c14b8020'
AND (
token = '8tu1GoV0HzOa87K+eyhdCbrIq/Ha4iaVYYaXpD2o8eU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)