UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KvW2kEW+5vVhx2F4MB3r5husccyNGfAZGrssL8Y6yOM='
WHERE
key_id = '98a211aecff50e564fd66db2d809e4e98ae0c59f3587f12119782420da6534d2'
AND (
token = 'KvW2kEW+5vVhx2F4MB3r5husccyNGfAZGrssL8Y6yOM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)