UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XH/RE4ze1LZ0Lz871D7oZ2dNUlScIvElHZheWM6z51I='
WHERE
key_id = '97b15d72feddd31fba8e478c71a421754bc00532324a173d4ab0ed58ff234710'
AND (
token = 'XH/RE4ze1LZ0Lz871D7oZ2dNUlScIvElHZheWM6z51I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)