UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'V700wT2ZManVLDt+lwtxlj7u6LdO64nixFj5AP6CF84=' 
WHERE 
  key_id = '7eb1ece7b44ac73e9c801a1aaa0a9e0dd1d07123646c34a636212d611bd63feb' 
  AND (
    token = 'V700wT2ZManVLDt+lwtxlj7u6LdO64nixFj5AP6CF84=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022