UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '3Z5E2aPVfDwHRf+4+S3N2VQSiwWK8bEZKTmJ9BR55e4=' 
WHERE 
  key_id = 'd6c2811a482d5883bd13b55679d471f0f217e35a454d6d1d46f81ed56ce3fa7f' 
  AND (
    token = '3Z5E2aPVfDwHRf+4+S3N2VQSiwWK8bEZKTmJ9BR55e4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029