UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QNWlu0cyoyqP5AlYbG+5bT5IN2jbvGrh+f67XNnCRL4='
WHERE
key_id = '7e9e7d938a513599bca670650a5c063dc8a31ce6726a55bfd883dad129793865'
AND (
token = 'QNWlu0cyoyqP5AlYbG+5bT5IN2jbvGrh+f67XNnCRL4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)