UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4Ki9usy33drBHH3KK77Q2KkgieFTG/OEZfSsu8xXp3s='
WHERE
key_id = 'e87e7466f3de3e4e5c59a9015ca031c09371706c899a842a0e247b31123d44c7'
AND (
token = '4Ki9usy33drBHH3KK77Q2KkgieFTG/OEZfSsu8xXp3s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)