UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MFN4lcX7VYS+4gFokndCtsBu2uYzY+KX6HNlsgvO94k='
WHERE
key_id = 'ddf07124536099d1890f84e00cb332c711a33fbed20f7b5e024bf5b60f770da9'
AND (
token = 'MFN4lcX7VYS+4gFokndCtsBu2uYzY+KX6HNlsgvO94k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)