UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r8tITz475CGQhj8ypRQ5reMb2gFkI67XdnpbtTr7i+g='
WHERE
key_id = '0c1ee9daae361521fd02dcabfb0351f881c9d236740d1ea979a541c960a7260c'
AND (
token = 'r8tITz475CGQhj8ypRQ5reMb2gFkI67XdnpbtTr7i+g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)