UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+0/YQ+tUodw8Nsk6esL/cNVJatx2HWG+290doYmNPNA=' 
WHERE 
  key_id = '8ac7fc1e4d3b786173641c4cdbbd7e359e1a196abef0a18365a3b0725e6dec6a' 
  AND (
    token = '+0/YQ+tUodw8Nsk6esL/cNVJatx2HWG+290doYmNPNA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00050