UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'MP/Bk59FvB+v/ZawEHxTJtzGt7/jU83wqc6gNbIpYwM=' 
WHERE 
  key_id = 'd4b4ba6919e980d07df99c46f1907ad715f0f732b058b990c1fbea201b8effb5' 
  AND (
    token = 'MP/Bk59FvB+v/ZawEHxTJtzGt7/jU83wqc6gNbIpYwM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035