UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '99Bgs2PFIqHiVvTSoH6obbIC8CwHllfF3Dv8ilS9Bjc='
WHERE
key_id = '49ef16eea8aca219909f2aa3be0322809c896a726cefb78a270c41cf643900fd'
AND (
token = '99Bgs2PFIqHiVvTSoH6obbIC8CwHllfF3Dv8ilS9Bjc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)