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