UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5wZsObcrk5VxV1pPXvIkHX5SjtinjmTE3v0cvKUXyd4='
WHERE
key_id = '1ee52f37c9fc78466425c1521fb7cc7b49a87905b8ea17a196bd44ad24facc3d'
AND (
token = '5wZsObcrk5VxV1pPXvIkHX5SjtinjmTE3v0cvKUXyd4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)