UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'zK4BtDyqXNf8sHwfUTg0sby0QneuQrFr6TdIXnQC+oc=' 
WHERE 
  key_id = 'b0ce7e15fc6d7a2f101068e35c08eb19be380f92a54c06b6daf4d06e0b2c98cb' 
  AND (
    token = 'zK4BtDyqXNf8sHwfUTg0sby0QneuQrFr6TdIXnQC+oc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00037