UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd/hZ5s7dpis2OqpCdOaJV3545hiPH10bHXhLBFgMDhw='
WHERE
key_id = 'fd09389a5cac235b2017a172e00e09f9c587e2864caa3e420495f92310b94163'
AND (
token = 'd/hZ5s7dpis2OqpCdOaJV3545hiPH10bHXhLBFgMDhw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)