UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XjHERZ5RwJbCvD3CvmBWW97ig9hCVdW2sC6RWkUiLw4='
WHERE
key_id = '791f430204c99bbea9007a97f4d872a0de4758a1399e2f2355693abef854df75'
AND (
token = 'XjHERZ5RwJbCvD3CvmBWW97ig9hCVdW2sC6RWkUiLw4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)