UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yWIPiCwR58bZX+7+UJ/68X+3samy+xkyo/ofjCCmb4M='
WHERE
key_id = 'f4d57073120d457607398042c722e19057479db183fad8be0eaf8aeae389a376'
AND (
token = 'yWIPiCwR58bZX+7+UJ/68X+3samy+xkyo/ofjCCmb4M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)