UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IfKTFBw+W/BjylyU99op0tgGfreKxr/RxRUH4Ou3ITA='
WHERE
key_id = 'd42b5bd040fefab9269a05f24b102180baae15dbce836b9656f9afc9f3bc663b'
AND (
token = 'IfKTFBw+W/BjylyU99op0tgGfreKxr/RxRUH4Ou3ITA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)