UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZqB/fqtdvm5gXwgb2Z411xrUW0hyeWpZ0YHgzW7ffvk='
WHERE
key_id = '6cd9e8dacef846130f809c2d52f510de091dc6902ef4737fd5ef7fb6b13af57f'
AND (
token = 'ZqB/fqtdvm5gXwgb2Z411xrUW0hyeWpZ0YHgzW7ffvk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)