UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Hkmtds22+y1hzVBsROU8qS4vL7S0eBmwD47MDwk75p8=' 
WHERE 
  key_id = 'bbf78c3653079f4b78a7ef8f2b4a3e573f5eb41472970c92da8e526346f59063' 
  AND (
    token = 'Hkmtds22+y1hzVBsROU8qS4vL7S0eBmwD47MDwk75p8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022