UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zpl7wmdT6rGKHMiZ3UvIKFc4BzERtYE+dDx/gi2GQ2A='
WHERE
key_id = '7adc66c1ec45f57131e9b8bf88c2562114a9363840fa66def835ef201285960f'
AND (
token = 'Zpl7wmdT6rGKHMiZ3UvIKFc4BzERtYE+dDx/gi2GQ2A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)