UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xIAaOYyPiCYbZigoZ7aI+JrcL790qnOJvdv2OoRmCaU='
WHERE
key_id = '0eea0baa4b13377330f40503f308a7d2d464f3f4483b555f914c3d07519e2f37'
AND (
token = 'xIAaOYyPiCYbZigoZ7aI+JrcL790qnOJvdv2OoRmCaU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)