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