UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vxztj7All9YK1TJAg793Hz0H1HZ7CfSNnEtscc5x7vQ='
WHERE
key_id = 'bd52a4a1549dbd4bab3c1fac8c9c1944597e49fac0417bee01c2590f20019a04'
AND (
token = 'vxztj7All9YK1TJAg793Hz0H1HZ7CfSNnEtscc5x7vQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)