UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3uwgxmaFEEJ1wcf8cViM1/XlYrbegl7DTqAJ8MUvuoE='
WHERE
key_id = 'ca31a331f1ea916f2815e0cfe56ca906c6cd6740501239eb7dc50daac520b422'
AND (
token = '3uwgxmaFEEJ1wcf8cViM1/XlYrbegl7DTqAJ8MUvuoE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)