UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LVV0ED7zWeJ0LjnvaZcTmFejUMprikSl7ANrykKnuNo='
WHERE
key_id = '78d798cc3254035f92dc8b3fbd4dff084c7759bfc7b4b780ced222d8b9c4592e'
AND (
token = 'LVV0ED7zWeJ0LjnvaZcTmFejUMprikSl7ANrykKnuNo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)