UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XIOIan11h/Xh7tncc2H7LnzGO47W3jt7HWUWmS4CizU='
WHERE
key_id = 'c0932bade4a948e80d80012b74897ddd792d2de981876f5e6236a0468931a4ab'
AND (
token = 'XIOIan11h/Xh7tncc2H7LnzGO47W3jt7HWUWmS4CizU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)