UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8caFZYjP0yjuQ0UMlqrObDBA1WXNdap8LUAXS8rEQAA='
WHERE
key_id = '0fce8f056659547e9e2f146d97aedcd09fd34ae6561197498b71d6eac9449244'
AND (
token = '8caFZYjP0yjuQ0UMlqrObDBA1WXNdap8LUAXS8rEQAA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)