UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sUx8xzsrpIl0+77b3CtxhbPVXTPz7yxqHei1eowtdTM='
WHERE
key_id = '29a80e92c600810ba9bd051161f6aab3cff14e5e4cca74b8baa7efe13c81a347'
AND (
token = 'sUx8xzsrpIl0+77b3CtxhbPVXTPz7yxqHei1eowtdTM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)