UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BRTnXsTTpt6mPRiK491UyPuPLmzTfsFp6SiA1tNXTi4='
WHERE
key_id = '6ddaf9e1c1b126e43fa3150b15f5770205e880225f23c449f5d6c827ffa4f7cc'
AND (
token = 'BRTnXsTTpt6mPRiK491UyPuPLmzTfsFp6SiA1tNXTi4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)