UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'eOI7GrXUs8Z4gPTc/0Ngx7/Tt0uFwEL+U8n3pYcx694=' 
WHERE 
  key_id = '1c0c7a0fb5af5ea76b9e36f219ca8e7858673a7520802b02cba5e58c628e2689' 
  AND (
    token = 'eOI7GrXUs8Z4gPTc/0Ngx7/Tt0uFwEL+U8n3pYcx694=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029