UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8XYzQZIejo4iCMOkn05D0v4hurBXdGPPcd27pWtZf94='
WHERE
key_id = '4b33e068e30508f3183a283b10b62d109baf8cb2ed4f88dbff3316267834b7fe'
AND (
token = '8XYzQZIejo4iCMOkn05D0v4hurBXdGPPcd27pWtZf94='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)