UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'wYooZ4k8gSp4XtLhtObv3/Us76Y0uW95zc3tICvUmkI=' 
WHERE 
  key_id = '7b3ecc59b0db32799139533fc9d60bd459963f9e74cde573e84b3edcdb3fd1f2' 
  AND (
    token = 'wYooZ4k8gSp4XtLhtObv3/Us76Y0uW95zc3tICvUmkI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029