UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rzVRlG9WYQ7Q3OQuyrXaYWY51et6GOON9nvtYrBO7ok='
WHERE
key_id = '226731c4263f72f602053497c534af63a3ea9c033252d879b7a9ec27166629f6'
AND (
token = 'rzVRlG9WYQ7Q3OQuyrXaYWY51et6GOON9nvtYrBO7ok='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)