UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pMJrRoRbQA9o5IGHYRzsd+fpPfO8xOFSGrLMcmseirw='
WHERE
key_id = 'de279fb55b68de57721f146ff4c224408f37d0bb45efbbe26f1e3a778c8fd8bf'
AND (
token = 'pMJrRoRbQA9o5IGHYRzsd+fpPfO8xOFSGrLMcmseirw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)