UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S8/tYjS23jLkw+63aSIitaQTZXpXgvpi7MZKdkg2+r0='
WHERE
key_id = 'f79eba89a6ff46813d86637391837682ad5fce5e7a3a1b3e33df1b422bc638dc'
AND (
token = 'S8/tYjS23jLkw+63aSIitaQTZXpXgvpi7MZKdkg2+r0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)