UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K6oc1EBG91pmeFMKmkkN5RyqbQkB/EjKjMdEDw6zEcw='
WHERE
key_id = 'f2c6552a4b7278262a294417ac14e0ccf92e09c3c03072b29df3bc6afdb9cd04'
AND (
token = 'K6oc1EBG91pmeFMKmkkN5RyqbQkB/EjKjMdEDw6zEcw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)