UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'BgVypz+L3WQPZCpua7pK7NHLpemTdZ5a0rMxVyHfrQQ=' 
WHERE 
  key_id = '3d94a0a8d7d46bfcbeb31a85f59c371e269158c702688cd2e08e067a11084b34' 
  AND (
    token = 'BgVypz+L3WQPZCpua7pK7NHLpemTdZ5a0rMxVyHfrQQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00045