UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N6tLIACNHDpFiVekWisuctzFoy8y692784zT7mR+JZk='
WHERE
key_id = '37de8bc1e967685fad6556da85bd8121d17365bc073be07a8cf7d3604347cbae'
AND (
token = 'N6tLIACNHDpFiVekWisuctzFoy8y692784zT7mR+JZk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)