UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ETLToVIy1tCnXw3QG+o3Bi55P9b/DJv+VKoP6IcX6Ck=' 
WHERE 
  key_id = '79ab092244e7163a98b0cd72e1d038b72a9e8352d6c1bed2b6186600bd70464f' 
  AND (
    token = 'ETLToVIy1tCnXw3QG+o3Bi55P9b/DJv+VKoP6IcX6Ck=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00052