UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xWk1J5z8b5xcUySlKuvZgTwyi3v6bE1lhmbhVO3cwa8='
WHERE
key_id = '940c565fbf54781edd77e83b7fe6f861719d46da0ac90fe5ac1cad2c2d07e3fc'
AND (
token = 'xWk1J5z8b5xcUySlKuvZgTwyi3v6bE1lhmbhVO3cwa8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)