UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3B5KZKW2vwaWaVJ1IoV8bawySEl8abW4kpqwAAAcn0Y='
WHERE
key_id = 'b8f5729a4f405fe54a09bf13eae995f3a4e0f1139fe492f7e97cc2be19951840'
AND (
token = '3B5KZKW2vwaWaVJ1IoV8bawySEl8abW4kpqwAAAcn0Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)